/*
 Navicat Premium Data Transfer

 Source Server         : hua-boot
 Source Server Type    : MySQL
 Source Server Version : 50717 (5.7.17)
 Source Host           : localhost:3306
 Source Schema         : hua-boot

 Target Server Type    : MySQL
 Target Server Version : 50717 (5.7.17)
 File Encoding         : 65001

 Date: 17/09/2023 17:09:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gen_base_class
-- ----------------------------
DROP TABLE IF EXISTS `gen_base_class`;
CREATE TABLE `gen_base_class` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `package_name` varchar(200) DEFAULT NULL COMMENT '基类包名',
  `code` varchar(200) DEFAULT NULL COMMENT '基类编码',
  `fields` varchar(500) DEFAULT NULL COMMENT '基类字段，多个用英文逗号分隔',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='基类管理';

-- ----------------------------
-- Records of gen_base_class
-- ----------------------------
BEGIN;
INSERT INTO `gen_base_class` (`id`, `package_name`, `code`, `fields`, `remark`, `create_time`) VALUES (1, 'net.maku.framework.mybatis.entity', 'BaseEntity', 'id,creator,create_time,updater,update_time,version,deleted', '使用该基类，则需要表里有这些字段', '2023-08-12 20:13:24');
COMMIT;

-- ----------------------------
-- Table structure for gen_datasource
-- ----------------------------
DROP TABLE IF EXISTS `gen_datasource`;
CREATE TABLE `gen_datasource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `db_type` varchar(200) DEFAULT NULL COMMENT '数据库类型',
  `conn_name` varchar(200) NOT NULL COMMENT '连接名',
  `conn_url` varchar(500) DEFAULT NULL COMMENT 'URL',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据源管理';

-- ----------------------------
-- Records of gen_datasource
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gen_field_type
-- ----------------------------
DROP TABLE IF EXISTS `gen_field_type`;
CREATE TABLE `gen_field_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `column_type` varchar(200) DEFAULT NULL COMMENT '字段类型',
  `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型',
  `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `column_type` (`column_type`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='字段类型管理';

-- ----------------------------
-- Records of gen_field_type
-- ----------------------------
BEGIN;
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (1, 'datetime', 'Date', 'java.util.Date', '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (2, 'date', 'Date', 'java.util.Date', '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (3, 'tinyint', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (4, 'smallint', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (5, 'mediumint', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (6, 'int', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (7, 'integer', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (8, 'bigint', 'Long', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (9, 'float', 'Float', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (10, 'double', 'Double', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (11, 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (12, 'bit', 'Boolean', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (13, 'char', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (14, 'varchar', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (15, 'tinytext', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (16, 'text', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (17, 'mediumtext', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (18, 'longtext', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (19, 'timestamp', 'Date', 'java.util.Date', '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (20, 'NUMBER', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (21, 'BINARY_INTEGER', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (22, 'BINARY_FLOAT', 'Float', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (23, 'BINARY_DOUBLE', 'Double', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (24, 'VARCHAR2', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (25, 'NVARCHAR', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (26, 'NVARCHAR2', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (27, 'CLOB', 'String', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (28, 'int8', 'Long', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (29, 'int4', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (30, 'int2', 'Integer', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_field_type` (`id`, `column_type`, `attr_type`, `package_name`, `create_time`) VALUES (31, 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2023-08-12 20:13:24');
COMMIT;

-- ----------------------------
-- Table structure for gen_project_modify
-- ----------------------------
DROP TABLE IF EXISTS `gen_project_modify`;
CREATE TABLE `gen_project_modify` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `project_name` varchar(100) DEFAULT NULL COMMENT '项目名',
  `project_code` varchar(100) DEFAULT NULL COMMENT '项目标识',
  `project_package` varchar(100) DEFAULT NULL COMMENT '项目包名',
  `project_path` varchar(200) DEFAULT NULL COMMENT '项目路径',
  `modify_project_name` varchar(100) DEFAULT NULL COMMENT '变更项目名',
  `modify_project_code` varchar(100) DEFAULT NULL COMMENT '变更标识',
  `modify_project_package` varchar(100) DEFAULT NULL COMMENT '变更包名',
  `exclusions` varchar(200) DEFAULT NULL COMMENT '排除文件',
  `modify_suffix` varchar(200) DEFAULT NULL COMMENT '变更文件',
  `modify_tmp_path` varchar(100) DEFAULT NULL COMMENT '变更临时路径',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='项目名变更';

-- ----------------------------
-- Records of gen_project_modify
-- ----------------------------
BEGIN;
INSERT INTO `gen_project_modify` (`id`, `project_name`, `project_code`, `project_package`, `project_path`, `modify_project_name`, `modify_project_code`, `modify_project_package`, `exclusions`, `modify_suffix`, `modify_tmp_path`, `create_time`) VALUES (1, 'maku-boot', 'maku', 'net.maku', 'D:/makunet/maku-boot', 'baba-boot', 'baba', 'com.baba', '.git,.idea,target,logs', 'java,xml,yml,txt', NULL, '2023-08-12 20:13:24');
INSERT INTO `gen_project_modify` (`id`, `project_name`, `project_code`, `project_package`, `project_path`, `modify_project_name`, `modify_project_code`, `modify_project_package`, `exclusions`, `modify_suffix`, `modify_tmp_path`, `create_time`) VALUES (2, 'maku-cloud', 'maku', 'net.maku', 'D:/makunet/maku-cloud', 'baba-cloud', 'baba', 'com.baba', '.git,.idea,target,logs', 'java,xml,yml,txt', NULL, '2023-08-12 20:13:24');
COMMIT;

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `table_name` varchar(200) DEFAULT NULL COMMENT '表名',
  `class_name` varchar(200) DEFAULT NULL COMMENT '类名',
  `table_comment` varchar(200) DEFAULT NULL COMMENT '说明',
  `author` varchar(200) DEFAULT NULL COMMENT '作者',
  `email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `package_name` varchar(200) DEFAULT NULL COMMENT '项目包名',
  `version` varchar(200) DEFAULT NULL COMMENT '项目版本号',
  `generator_type` tinyint(4) DEFAULT NULL COMMENT '生成方式  0：zip压缩包   1：自定义目录',
  `backend_path` varchar(500) DEFAULT NULL COMMENT '后端生成路径',
  `frontend_path` varchar(500) DEFAULT NULL COMMENT '前端生成路径',
  `module_name` varchar(200) DEFAULT NULL COMMENT '模块名',
  `function_name` varchar(200) DEFAULT NULL COMMENT '功能名',
  `form_layout` tinyint(4) DEFAULT NULL COMMENT '表单布局  1：一列   2：两列',
  `datasource_id` bigint(20) DEFAULT NULL COMMENT '数据源ID',
  `baseclass_id` bigint(20) DEFAULT NULL COMMENT '基类ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表';

-- ----------------------------
-- Records of gen_table
-- ----------------------------
BEGIN;
INSERT INTO `gen_table` (`id`, `table_name`, `class_name`, `table_comment`, `author`, `email`, `package_name`, `version`, `generator_type`, `backend_path`, `frontend_path`, `module_name`, `function_name`, `form_layout`, `datasource_id`, `baseclass_id`, `create_time`) VALUES (2, 'sys_role', 'SysRole', '角色管理', 'ffdmw', 'xxx', 'com.huaboot.system', '1.0.0', 0, 'D:\\\\hua-boot\\\\hua-server', 'D:\\\\hua-boot\\\\hua-ui', 'system', 'role', 1, NULL, NULL, '2023-09-02 21:10:31');
INSERT INTO `gen_table` (`id`, `table_name`, `class_name`, `table_comment`, `author`, `email`, `package_name`, `version`, `generator_type`, `backend_path`, `frontend_path`, `module_name`, `function_name`, `form_layout`, `datasource_id`, `baseclass_id`, `create_time`) VALUES (3, 'sys_org', 'SysOrg', '机构管理', 'ff', 'xxx', 'com.huaboot.system', '1.0.0', 0, 'D:\\\\hua-boot\\\\hua-server', 'D:\\\\hua-boot\\\\hua-ui', 'system', 'org', 1, NULL, NULL, '2023-09-02 21:10:31');
INSERT INTO `gen_table` (`id`, `table_name`, `class_name`, `table_comment`, `author`, `email`, `package_name`, `version`, `generator_type`, `backend_path`, `frontend_path`, `module_name`, `function_name`, `form_layout`, `datasource_id`, `baseclass_id`, `create_time`) VALUES (4, 'sys_menu', 'SysMenu', '菜单管理', 'ff', 'xxx', 'com.huaboot.system', '1.0.0', 0, 'D:\\\\hua-boot\\\\hua-server', 'D:\\\\hua-boot\\\\hua-ui', 'system', 'menu', 1, NULL, NULL, '2023-09-02 21:10:31');
INSERT INTO `gen_table` (`id`, `table_name`, `class_name`, `table_comment`, `author`, `email`, `package_name`, `version`, `generator_type`, `backend_path`, `frontend_path`, `module_name`, `function_name`, `form_layout`, `datasource_id`, `baseclass_id`, `create_time`) VALUES (5, 'sys_dict_type', 'SysDictType', '字典类型', 'ff', 'xxx', 'com.huaboot.system', '1.0.0', 0, 'D:\\\\hua-boot\\\\hua-server', 'D:\\\\hua-boot\\\\hua-ui', 'system', 'type', 1, NULL, NULL, '2023-09-02 21:10:31');
INSERT INTO `gen_table` (`id`, `table_name`, `class_name`, `table_comment`, `author`, `email`, `package_name`, `version`, `generator_type`, `backend_path`, `frontend_path`, `module_name`, `function_name`, `form_layout`, `datasource_id`, `baseclass_id`, `create_time`) VALUES (6, 'sys_dict_data', 'SysDictData', '字典数据', 'ff', 'xxx', 'com.huaboot.system', '1.0.0', 0, 'D:\\\\hua-boot\\\\hua-server', 'D:\\\\hua-boot\\\\hua-ui', 'system', 'data', 1, NULL, NULL, '2023-09-02 21:10:31');
COMMIT;

-- ----------------------------
-- Table structure for gen_table_field
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_field`;
CREATE TABLE `gen_table_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `table_id` bigint(20) DEFAULT NULL COMMENT '表ID',
  `field_name` varchar(200) DEFAULT NULL COMMENT '字段名称',
  `field_type` varchar(200) DEFAULT NULL COMMENT '字段类型',
  `field_comment` varchar(200) DEFAULT NULL COMMENT '字段说明',
  `attr_name` varchar(200) DEFAULT NULL COMMENT '属性名',
  `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型',
  `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `auto_fill` varchar(20) DEFAULT NULL COMMENT '自动填充  DEFAULT、INSERT、UPDATE、INSERT_UPDATE',
  `primary_pk` tinyint(4) DEFAULT NULL COMMENT '主键 0：否  1：是',
  `base_field` tinyint(4) DEFAULT NULL COMMENT '基类字段 0：否  1：是',
  `form_item` tinyint(4) DEFAULT NULL COMMENT '表单项 0：否  1：是',
  `form_required` tinyint(4) DEFAULT NULL COMMENT '表单必填 0：否  1：是',
  `form_type` varchar(200) DEFAULT NULL COMMENT '表单类型',
  `form_dict` varchar(200) DEFAULT NULL COMMENT '表单字典类型',
  `form_validator` varchar(200) DEFAULT NULL COMMENT '表单效验',
  `grid_item` tinyint(4) DEFAULT NULL COMMENT '列表项 0：否  1：是',
  `grid_sort` tinyint(4) DEFAULT NULL COMMENT '列表排序 0：否  1：是',
  `query_item` tinyint(4) DEFAULT NULL COMMENT '查询项 0：否  1：是',
  `query_type` varchar(200) DEFAULT NULL COMMENT '查询方式',
  `query_form_type` varchar(200) DEFAULT NULL COMMENT '查询表单类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表字段';

-- ----------------------------
-- Records of gen_table_field
-- ----------------------------
BEGIN;
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (23, 1, 'id', 'bigint', '学生ID', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (24, 1, 'name', 'varchar', '姓名', 'name', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (25, 1, 'gender', 'tinyint', '性别', 'gender', 'Integer', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (26, 1, 'age', 'int', '年龄', 'age', 'Integer', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (27, 1, 'class_name', 'varchar', '班级', 'className', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (28, 1, 'version', 'int', '版本号', 'version', 'Integer', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (29, 1, 'deleted', 'tinyint', '删除标识', 'deleted', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (30, 1, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (31, 1, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (32, 1, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (34, 1, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (35, 2, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (36, 2, 'name', 'varchar', '角色名称', 'name', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 1, 'text', NULL, NULL, 1, 0, 1, 'right like', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (37, 2, 'role_code', 'varchar', '角色编码', 'roleCode', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 1, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (38, 2, 'remark', 'varchar', '备注', 'remark', 'String', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (39, 2, 'data_scope', 'tinyint', '数据范围  0：全部数据  1：本机构及子机构数据  2：本机构数据  3：本人数据  4：自定义数据', 'dataScope', 'Integer', NULL, 4, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (40, 2, 'org_id', 'bigint', '机构ID', 'orgId', 'Long', NULL, 5, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (41, 2, 'tenant_id', 'bigint', '租户ID', 'tenantId', 'Long', NULL, 6, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (42, 2, 'version', 'int', '版本号', 'version', 'Integer', NULL, 7, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (43, 2, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 8, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (44, 2, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 9, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (45, 2, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 10, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (46, 2, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 11, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (47, 2, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 12, 'DEFAULT', 0, 0, 0, 0, 'text', NULL, NULL, 0, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (48, 3, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (49, 3, 'pid', 'bigint', '上级ID', 'pid', 'Long', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (50, 3, 'name', 'varchar', '机构名称', 'name', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (51, 3, 'sort', 'int', '排序', 'sort', 'Integer', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (52, 3, 'tenant_id', 'bigint', '租户ID', 'tenantId', 'Long', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (53, 3, 'version', 'int', '版本号', 'version', 'Integer', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (54, 3, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (55, 3, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (56, 3, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (57, 3, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (58, 3, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (59, 4, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (60, 4, 'pid', 'bigint', '上级ID，一级菜单为0', 'pid', 'Long', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (61, 4, 'name', 'varchar', '菜单名称', 'name', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (62, 4, 'url', 'varchar', '菜单URL', 'url', 'String', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (63, 4, 'authority', 'varchar', '授权标识(多个用逗号分隔，如：sys:menu:list,sys:menu:save)', 'authority', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (64, 4, 'type', 'tinyint', '类型   0：菜单   1：按钮   2：接口', 'type', 'Integer', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (65, 4, 'open_style', 'tinyint', '打开方式   0：内部   1：外部', 'openStyle', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (66, 4, 'icon', 'varchar', '菜单图标', 'icon', 'String', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (67, 4, 'sort', 'int', '排序', 'sort', 'Integer', NULL, 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (68, 4, 'version', 'int', '版本号', 'version', 'Integer', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (69, 4, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (70, 4, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 11, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (71, 4, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 12, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (72, 4, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 13, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (73, 4, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 14, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (74, 5, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (75, 5, 'dict_type', 'varchar', '字典类型', 'dictType', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (76, 5, 'dict_name', 'varchar', '字典名称', 'dictName', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (77, 5, 'dict_source', 'tinyint', '来源  0：字典数据  1：动态SQL', 'dictSource', 'Integer', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (78, 5, 'dict_sql', 'varchar', '动态SQL', 'dictSql', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (79, 5, 'remark', 'varchar', '备注', 'remark', 'String', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (80, 5, 'sort', 'int', '排序', 'sort', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (81, 5, 'tenant_id', 'bigint', '租户ID', 'tenantId', 'Long', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (82, 5, 'version', 'int', '版本号', 'version', 'Integer', NULL, 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (83, 5, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (84, 5, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (85, 5, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 11, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (86, 5, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 12, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (87, 5, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 13, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (88, 6, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (89, 6, 'dict_type_id', 'bigint', '字典类型ID', 'dictTypeId', 'Long', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (90, 6, 'dict_label', 'varchar', '字典标签', 'dictLabel', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (91, 6, 'dict_value', 'varchar', '字典值', 'dictValue', 'String', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (92, 6, 'label_class', 'varchar', '标签样式', 'labelClass', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (93, 6, 'remark', 'varchar', '备注', 'remark', 'String', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (94, 6, 'sort', 'int', '排序', 'sort', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (95, 6, 'tenant_id', 'bigint', '租户ID', 'tenantId', 'Long', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (96, 6, 'version', 'int', '版本号', 'version', 'Integer', NULL, 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (97, 6, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (98, 6, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (99, 6, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 11, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (100, 6, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 12, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (101, 6, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 13, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (102, 7, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (103, 7, 'post_code', 'varchar', '岗位编码', 'postCode', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (104, 7, 'post_name', 'varchar', '岗位名称', 'postName', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (105, 7, 'sort', 'int', '排序', 'sort', 'Integer', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (106, 7, 'status', 'tinyint', '状态  0：停用   1：正常', 'status', 'Integer', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (107, 7, 'tenant_id', 'bigint', '租户ID', 'tenantId', 'Long', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (108, 7, 'version', 'int', '版本号', 'version', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (109, 7, 'deleted', 'tinyint', '删除标识  0：正常   1：已删除', 'deleted', 'Integer', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (110, 7, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (111, 7, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (112, 7, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (113, 7, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 11, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (114, 8, 'id', 'bigint', '学生ID', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (115, 8, 'name', 'varchar', '姓名', 'name', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (116, 8, 'gender', 'tinyint', '性别', 'gender', 'Integer', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (117, 8, 'age', 'int', '年龄', 'age', 'Integer', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (118, 8, 'class_name', 'varchar', '班级', 'className', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (119, 8, 'version', 'int', '版本号', 'version', 'Integer', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (120, 8, 'deleted', 'tinyint', '删除标识', 'deleted', 'Integer', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (121, 8, 'creator', 'bigint', '创建者', 'creator', 'Long', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (122, 8, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (123, 8, 'updater', 'bigint', '更新者', 'updater', 'Long', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (124, 8, 'update_time', 'datetime', '更新时间', 'updateTime', 'Date', 'java.util.Date', 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (125, 9, 'id', 'bigint', 'id', 'id', 'Long', NULL, 0, 'DEFAULT', 1, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (126, 9, 'table_name', 'varchar', '表名', 'tableName', 'String', NULL, 1, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (127, 9, 'class_name', 'varchar', '类名', 'className', 'String', NULL, 2, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (128, 9, 'table_comment', 'varchar', '说明', 'tableComment', 'String', NULL, 3, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (129, 9, 'author', 'varchar', '作者', 'author', 'String', NULL, 4, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (130, 9, 'email', 'varchar', '邮箱', 'email', 'String', NULL, 5, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (131, 9, 'package_name', 'varchar', '项目包名', 'packageName', 'String', NULL, 6, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (132, 9, 'version', 'varchar', '项目版本号', 'version', 'String', NULL, 7, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (133, 9, 'generator_type', 'tinyint', '生成方式  0：zip压缩包   1：自定义目录', 'generatorType', 'Integer', NULL, 8, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (134, 9, 'backend_path', 'varchar', '后端生成路径', 'backendPath', 'String', NULL, 9, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (135, 9, 'frontend_path', 'varchar', '前端生成路径', 'frontendPath', 'String', NULL, 10, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (136, 9, 'module_name', 'varchar', '模块名', 'moduleName', 'String', NULL, 11, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (137, 9, 'function_name', 'varchar', '功能名', 'functionName', 'String', NULL, 12, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (138, 9, 'form_layout', 'tinyint', '表单布局  1：一列   2：两列', 'formLayout', 'Integer', NULL, 13, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (139, 9, 'datasource_id', 'bigint', '数据源ID', 'datasourceId', 'Long', NULL, 14, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (140, 9, 'baseclass_id', 'bigint', '基类ID', 'baseclassId', 'Long', NULL, 15, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
INSERT INTO `gen_table_field` (`id`, `table_id`, `field_name`, `field_type`, `field_comment`, `attr_name`, `attr_type`, `package_name`, `sort`, `auto_fill`, `primary_pk`, `base_field`, `form_item`, `form_required`, `form_type`, `form_dict`, `form_validator`, `grid_item`, `grid_sort`, `query_item`, `query_type`, `query_form_type`) VALUES (141, 9, 'create_time', 'datetime', '创建时间', 'createTime', 'Date', 'java.util.Date', 16, 'DEFAULT', 0, 0, 1, 0, 'text', NULL, NULL, 1, 0, 0, '=', 'text');
COMMIT;

-- ----------------------------
-- Table structure for gen_test_student
-- ----------------------------
DROP TABLE IF EXISTS `gen_test_student`;
CREATE TABLE `gen_test_student` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '学生ID',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `gender` tinyint(4) DEFAULT NULL COMMENT '性别',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `class_name` varchar(50) DEFAULT NULL COMMENT '班级',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试2';

-- ----------------------------
-- Records of gen_test_student
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_attachment
-- ----------------------------
DROP TABLE IF EXISTS `sys_attachment`;
CREATE TABLE `sys_attachment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '附件名称',
  `url` varchar(255) NOT NULL COMMENT '附件地址',
  `size` bigint(20) DEFAULT NULL COMMENT '附件大小',
  `platform` varchar(50) DEFAULT NULL COMMENT '存储平台',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='附件管理';

-- ----------------------------
-- Records of sys_attachment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `dict_type_id` bigint(20) NOT NULL COMMENT '字典类型ID',
  `dict_label` varchar(255) NOT NULL COMMENT '字典标签',
  `dict_value` varchar(255) DEFAULT NULL COMMENT '字典值',
  `label_class` varchar(100) DEFAULT NULL COMMENT '标签样式',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 1, '停用', '0', 'danger', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 1, '正常', '1', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 2, '男', '0', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 2, '女', '1', 'success', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 2, '未知', '2', 'warning', '', 2, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 3, '正常', '1', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (7, 3, '停用', '0', 'danger', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (8, 4, '全部数据', '0', '', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (9, 4, '本机构及子机构数据', '1', '', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10, 4, '本机构数据', '2', '', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (11, 4, '本人数据', '3', '', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (12, 4, '自定义数据', '4', '', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (13, 5, '禁用', '0', 'danger', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (14, 5, '启用', '1', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (15, 6, '失败', '0', 'danger', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (16, 6, '成功', '1', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (17, 7, '登录成功', '0', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (18, 7, '退出成功', '1', 'warning', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (19, 7, '验证码错误', '2', 'danger', '', 2, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (20, 7, '账号密码错误', '3', 'danger', '', 3, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (21, 8, '否', '0', 'primary', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (22, 8, '是', '1', 'danger', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (23, 9, '是', '1', 'danger', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (24, 9, '否', '0', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (25, 10, '其它', '0', 'info', '', 10, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (26, 10, '查询', '1', 'primary', '', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (27, 10, '新增', '2', 'success', '', 1, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (28, 10, '修改', '3', 'warning', '', 2, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (29, 10, '删除', '4', 'danger', '', 3, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (30, 10, '导出', '5', 'info', '', 4, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `label_class`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (31, 10, '导入', '6', 'info', '', 5, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `dict_type` varchar(100) NOT NULL COMMENT '字典类型',
  `dict_name` varchar(255) NOT NULL COMMENT '字典名称',
  `dict_source` tinyint(4) DEFAULT '0' COMMENT '来源  0：字典数据  1：动态SQL',
  `dict_sql` varchar(500) DEFAULT NULL COMMENT '动态SQL',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 'post_status', '状态', 0, NULL, '岗位管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 'user_gender', '性别', 0, NULL, '用户管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 'user_status', '状态', 0, NULL, '用户管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 'role_data_scope', '数据范围', 0, NULL, '角色管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 'enable_disable', '状态', 0, NULL, '功能状态：启用 | 禁用 ', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 'success_fail', '状态', 0, NULL, '操作状态：成功 | 失败', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (7, 'login_operation', '操作信息', 0, NULL, '登录管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (8, 'params_type', '系统参数', 0, NULL, '参数管理', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (9, 'user_super_admin', '用户是否是超管', 0, NULL, '用户是否是超管', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `dict_source`, `dict_sql`, `remark`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10, 'log_operate_type', '操作类型', 0, NULL, '操作日志', 0, 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
COMMIT;

-- ----------------------------
-- Table structure for sys_log_login
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_login`;
CREATE TABLE `sys_log_login` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `ip` varchar(32) DEFAULT NULL COMMENT '登录IP',
  `address` varchar(32) DEFAULT NULL COMMENT '登录地点',
  `user_agent` varchar(500) DEFAULT NULL COMMENT 'User Agent',
  `status` tinyint(4) DEFAULT NULL COMMENT '登录状态  0：失败   1：成功',
  `operation` tinyint(3) unsigned DEFAULT NULL COMMENT '操作信息   0：登录成功   1：退出成功  2：验证码错误  3：账号密码错误',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志';

-- ----------------------------
-- Records of sys_log_login
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log_operate
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_operate`;
CREATE TABLE `sys_log_operate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `module` varchar(100) DEFAULT NULL COMMENT '模块名',
  `name` varchar(100) DEFAULT NULL COMMENT '操作名',
  `req_uri` varchar(200) DEFAULT NULL COMMENT '请求URI',
  `req_method` varchar(20) DEFAULT NULL COMMENT '请求方法',
  `req_params` text COMMENT '请求参数',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `address` varchar(32) DEFAULT NULL COMMENT '登录地点',
  `user_agent` varchar(500) DEFAULT NULL COMMENT 'User Agent',
  `operate_type` tinyint(4) DEFAULT NULL COMMENT '操作类型',
  `duration` int(11) NOT NULL COMMENT '执行时长',
  `status` tinyint(4) DEFAULT NULL COMMENT '操作状态  0：失败   1：成功',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `real_name` varchar(50) DEFAULT NULL COMMENT '操作人',
  `result_msg` varchar(500) DEFAULT NULL COMMENT '返回消息',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';

-- ----------------------------
-- Records of sys_log_operate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `name` varchar(200) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `authority` varchar(500) DEFAULT NULL COMMENT '授权标识(多个用逗号分隔，如：sys:menu:list,sys:menu:save)',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型   0：菜单   1：按钮   2：接口',
  `open_style` tinyint(4) DEFAULT NULL COMMENT '打开方式   0：内部   1：外部',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 0, '系统设置', NULL, NULL, 0, 0, 'icon-setting', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 1, '菜单管理', 'sys/menu/index', NULL, 0, 0, 'icon-menu', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 2, '查看', '', 'sys:menu:list', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 2, '新增', '', 'sys:menu:save', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 2, '修改', '', 'sys:menu:update,sys:menu:info', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 2, '删除', '', 'sys:menu:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (7, 1, '数据字典', 'sys/dict/type', '', 0, 0, 'icon-insertrowabove', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (8, 7, '查询', '', 'sys:dict:page', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (9, 7, '新增', '', 'sys:dict:save', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10, 7, '修改', '', 'sys:dict:update,sys:dict:info', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (11, 7, '删除', '', 'sys:dict:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (12, 0, '权限管理', '', '', 0, 0, 'icon-safetycertificate', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (13, 12, '岗位管理', 'sys/post/index', '', 0, 0, 'icon-solution', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (14, 13, '查询', '', 'sys:post:page', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (15, 13, '新增', '', 'sys:post:save', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (16, 13, '修改', '', 'sys:post:update,sys:post:info', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (17, 13, '删除', '', 'sys:post:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (18, 12, '机构管理', 'sys/org/index', '', 0, 0, 'icon-cluster', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (19, 18, '查询', '', 'sys:org:list', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (20, 18, '新增', '', 'sys:org:save', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (21, 18, '修改', '', 'sys:org:update,sys:org:info', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (22, 18, '删除', '', 'sys:org:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (23, 12, '角色管理', 'sys/role/index', '', 0, 0, 'icon-team', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (24, 23, '查询', '', 'sys:role:page', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (25, 23, '新增', '', 'sys:role:save,sys:role:menu,sys:org:list', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (26, 23, '修改', '', 'sys:role:update,sys:role:info,sys:role:menu,sys:org:list,sys:user:page', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (27, 23, '删除', '', 'sys:role:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (28, 12, '用户管理', 'sys/user/index', '', 0, 0, 'icon-user', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (29, 28, '查询', '', 'sys:user:page', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (30, 28, '新增', '', 'sys:user:save,sys:role:list', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (31, 28, '修改', '', 'sys:user:update,sys:user:info,sys:role:list', 1, 0, '', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (32, 28, '删除', '', 'sys:user:delete', 1, 0, '', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (33, 0, '应用管理', '', '', 0, 0, 'icon-appstore', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (34, 1, '附件管理', 'sys/attachment/index', NULL, 0, 0, 'icon-folder-fill', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (35, 34, '查看', '', 'sys:attachment:page', 1, 0, '', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (36, 34, '上传', '', 'sys:attachment:save', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (37, 34, '删除', '', 'sys:attachment:delete', 1, 0, '', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (38, 0, '日志管理', '', '', 0, 0, 'icon-filedone', 3, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (39, 38, '登录日志', 'sys/log/login', 'sys:log:login', 0, 0, 'icon-solution', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (40, 28, '导入', '', 'sys:user:import', 1, 0, '', 5, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (41, 28, '导出', '', 'sys:user:export', 1, 0, '', 6, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (42, 1, '参数管理', 'sys/params/index', 'sys:params:all', 0, 0, 'icon-filedone', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (43, 1, '接口文档', '{{apiUrl}}/doc.html', NULL, 0, 1, 'icon-file-text-fill', 10, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (44, 0, '在线开发', '', '', 0, 0, 'icon-cloud', 2, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (45, 44, 'Online表单开发', 'online/table/index', 'online:table:all', 0, 0, 'icon-table', 0, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `authority`, `type`, `open_style`, `icon`, `sort`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (46, 38, '操作日志', 'sys/log/operate', 'sys:operate:all', 0, 0, 'icon-file-text', 1, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
COMMIT;

-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID',
  `name` varchar(50) DEFAULT NULL COMMENT '机构名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='机构管理';

-- ----------------------------
-- Records of sys_org
-- ----------------------------
BEGIN;
INSERT INTO `sys_org` (`id`, `pid`, `name`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 0, '华boos', 0, NULL, NULL, 0, NULL, NULL, 6, '2023-09-09 21:10:03');
INSERT INTO `sys_org` (`id`, `pid`, `name`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 3, '宋🐶a', 0, NULL, 1, 1, 6, '2023-09-09 21:10:18', 6, '2023-09-09 21:22:59');
INSERT INTO `sys_org` (`id`, `pid`, `name`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 1, '事业一部', 0, NULL, 0, 0, 6, '2023-09-09 21:11:26', 6, '2023-09-09 21:11:26');
INSERT INTO `sys_org` (`id`, `pid`, `name`, `sort`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 1, '研发一部', 0, NULL, 0, 0, 6, '2023-09-09 21:12:05', 6, '2023-09-09 21:12:05');
COMMIT;

-- ----------------------------
-- Table structure for sys_params
-- ----------------------------
DROP TABLE IF EXISTS `sys_params`;
CREATE TABLE `sys_params` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `param_name` varchar(100) DEFAULT NULL COMMENT '参数名称',
  `param_type` tinyint(4) NOT NULL COMMENT '系统参数   0：否   1：是',
  `param_key` varchar(100) DEFAULT NULL COMMENT '参数键',
  `param_value` varchar(2000) DEFAULT NULL COMMENT '参数值',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='参数管理';

-- ----------------------------
-- Records of sys_params
-- ----------------------------
BEGIN;
INSERT INTO `sys_params` (`id`, `param_name`, `param_type`, `param_key`, `param_value`, `remark`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, '用户登录-验证码开关', 1, 'LOGIN_CAPTCHA', 'false', '是否开启验证码（true：开启，false：关闭）', 10000, 0, 0, 10000, '2023-09-09 17:02:15', 10000, '2023-09-09 17:02:15');
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `post_code` varchar(100) DEFAULT NULL COMMENT '岗位编码',
  `post_name` varchar(100) DEFAULT NULL COMMENT '岗位名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='岗位管理';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `sort`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 'jgs', '架构师', 1, 1, NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `sort`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 'java', '后端研发', 0, 1, NULL, 0, 0, 6, '2023-09-09 17:28:23', 6, '2023-09-09 17:28:23');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(50) DEFAULT NULL COMMENT '角色编码',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `data_scope` tinyint(4) DEFAULT NULL COMMENT '数据范围  0：全部数据  1：本机构及子机构数据  2：本机构数据  3：本人数据  4：自定义数据',
  `org_id` bigint(20) DEFAULT NULL COMMENT '机构ID',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_org_id` (`org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `role_code`, `remark`, `data_scope`, `org_id`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, '普通用户', 'pt', '', 2, NULL, NULL, 3, 0, 6, '2023-09-16 19:44:55', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role` (`id`, `name`, `role_code`, `remark`, `data_scope`, `org_id`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, '普通用户', 'pt', '', 3, NULL, NULL, 0, 1, 6, '2023-09-16 19:44:56', 6, '2023-09-16 19:45:03');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_data_scope
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_data_scope`;
CREATE TABLE `sys_role_data_scope` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `org_id` bigint(20) DEFAULT NULL COMMENT '机构ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色数据权限';

-- ----------------------------
-- Records of sys_role_data_scope
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COMMENT='角色菜单关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 1, 33, 0, 1, 6, '2023-09-16 19:44:56', 6, '2023-09-16 19:44:56');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 2, 33, 0, 1, 6, '2023-09-16 19:44:56', 6, '2023-09-16 19:44:56');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (39, 1, 12, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (40, 1, 28, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (41, 1, 29, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (42, 1, 30, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (43, 1, 31, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (44, 1, 32, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (45, 1, 40, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (46, 1, 41, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (47, 1, 33, 0, 0, 6, '2023-09-17 10:47:23', 6, '2023-09-17 10:47:23');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `real_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `avatar` varchar(200) DEFAULT NULL COMMENT '头像',
  `gender` tinyint(4) DEFAULT NULL COMMENT '性别   0：男   1：女   2：未知',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `org_id` bigint(20) DEFAULT NULL COMMENT '机构ID',
  `super_admin` tinyint(4) DEFAULT NULL COMMENT '超级管理员   0：否   1：是',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT '0' COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10003 DEFAULT CHARSET=utf8mb4 COMMENT='用户管理';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `password`, `real_name`, `avatar`, `gender`, `email`, `mobile`, `org_id`, `super_admin`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 'fanfan', '$2a$10$HSJGAHnxRsjOa1EyVV4uqeFTCmRp3xOQeeNP2Rkba8.mHY.AaTmEe', 'ffdmw', NULL, NULL, NULL, '15823391292', NULL, 1, 1, NULL, NULL, 0, NULL, '2023-09-09 16:59:55', NULL, '2023-09-09 16:59:55');
INSERT INTO `sys_user` (`id`, `username`, `password`, `real_name`, `avatar`, `gender`, `email`, `mobile`, `org_id`, `super_admin`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (11, 'huahua', '$2a$10$TF9KOR9tqeMzic3lu1dpEe1H1pNMrwGtA6YKak2PfcfmTvwoRRXHS', '华', NULL, NULL, NULL, '15930303901', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-09 14:48:43', NULL, '2023-09-09 14:48:43');
INSERT INTO `sys_user` (`id`, `username`, `password`, `real_name`, `avatar`, `gender`, `email`, `mobile`, `org_id`, `super_admin`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10000, 'admin', '{bcrypt}$2a$10$mW/yJPHjyueQ1g26WNBz0uxVPa0GQdJO1fFZmqdkqgMTGnyszlXxu', 'admin', 'https://cdn.maku.net/images/avatar.png', 0, 'babamu@126.com', '13612345678', NULL, 1, 1, 10000, 0, 0, 10000, '2023-09-09 14:48:51', 10000, '2023-09-09 14:48:51');
INSERT INTO `sys_user` (`id`, `username`, `password`, `real_name`, `avatar`, `gender`, `email`, `mobile`, `org_id`, `super_admin`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10001, 'ffdmw', '$2a$10$95/93Sj0EwembEzkmIek9.G5X3tP851xZ3XP3gCyc6p0FymmhTTPm', '范范大魔王', NULL, 1, '', '15930323901', 1, 0, 1, NULL, NULL, 0, NULL, '2023-09-16 20:12:32', NULL, '2023-09-17 16:58:09');
INSERT INTO `sys_user` (`id`, `username`, `password`, `real_name`, `avatar`, `gender`, `email`, `mobile`, `org_id`, `super_admin`, `status`, `tenant_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10002, 'huaa', '$2a$10$ksPhQ/xVlT5WJJ7y6o8suO53/yPaiATR6ii7lhQ3qA0BzUdmrmZEq', '华', NULL, 0, '', '15839390912', 4, 0, 1, NULL, NULL, 0, NULL, '2023-09-17 10:49:38', NULL, '2023-09-17 14:42:49');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `post_id` bigint(20) DEFAULT NULL COMMENT '岗位ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_post_id` (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='用户岗位关系';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 10001, 6, 0, 1, 6, '2023-09-16 20:12:33', 6, '2023-09-16 20:12:33');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 10001, 6, 0, 1, 6, '2023-09-16 20:30:15', 6, '2023-09-16 20:30:15');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 10002, 5, 0, 1, 6, '2023-09-17 10:00:55', 6, '2023-09-17 10:00:55');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 10002, 5, 0, 1, 6, '2023-09-17 13:34:35', 6, '2023-09-17 13:34:35');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 10002, 5, 0, 1, 6, '2023-09-17 14:15:47', 6, '2023-09-17 14:15:47');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 10002, 5, 0, 1, 6, '2023-09-17 14:21:52', 6, '2023-09-17 14:21:52');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (7, 10002, 5, 0, 1, 6, '2023-09-17 14:23:35', 6, '2023-09-17 14:23:35');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (8, 10002, 5, 0, 1, 6, '2023-09-17 14:28:22', 6, '2023-09-17 14:28:22');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (9, 10002, 5, 0, 1, 6, '2023-09-17 14:32:07', 6, '2023-09-17 14:32:07');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10, 10002, 5, 0, 1, 6, '2023-09-17 14:35:51', 6, '2023-09-17 14:35:51');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (11, 10002, 5, 0, 1, 6, '2023-09-17 14:42:40', 6, '2023-09-17 14:42:40');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (12, 10002, 5, 0, 0, 6, '2023-09-17 14:42:49', 6, '2023-09-17 14:42:49');
INSERT INTO `sys_user_post` (`id`, `user_id`, `post_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (13, 10001, 6, 0, 0, 6, '2023-09-17 16:58:10', 6, '2023-09-17 16:58:10');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '删除标识  0：正常   1：已删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (1, 1, 10001, 0, 1, 6, '2023-09-16 20:12:33', 6, '2023-09-16 20:12:33');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (2, 1, 10001, 0, 1, 6, '2023-09-16 20:30:15', 6, '2023-09-16 20:30:15');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (3, 1, 10002, 0, 1, 6, '2023-09-17 10:00:55', 6, '2023-09-17 10:00:55');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (4, 1, 10002, 0, 1, 6, '2023-09-17 13:34:35', 6, '2023-09-17 13:34:35');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (5, 1, 10002, 0, 1, 6, '2023-09-17 14:15:46', 6, '2023-09-17 14:15:46');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (6, 1, 10002, 0, 1, 6, '2023-09-17 14:21:52', 6, '2023-09-17 14:21:52');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (7, 1, 10002, 0, 1, 6, '2023-09-17 14:23:35', 6, '2023-09-17 14:23:35');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (8, 1, 10002, 0, 1, 6, '2023-09-17 14:28:22', 6, '2023-09-17 14:28:22');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (9, 1, 10002, 0, 1, 6, '2023-09-17 14:32:07', 6, '2023-09-17 14:32:07');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (10, 1, 10002, 0, 1, 6, '2023-09-17 14:35:51', 6, '2023-09-17 14:35:51');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (11, 1, 10002, 0, 1, 6, '2023-09-17 14:42:40', 6, '2023-09-17 14:42:40');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (12, 1, 10002, 0, 1, 6, '2023-09-17 14:42:49', 6, '2023-09-17 14:42:49');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (13, 1, 10001, 0, 1, 6, '2023-09-17 16:58:10', 6, '2023-09-17 16:58:10');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (14, 1, 10002, 0, 0, 6, '2023-09-17 17:05:34', 6, '2023-09-17 17:05:34');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (15, 1, 10001, 0, 1, 6, '2023-09-17 17:05:34', 6, '2023-09-17 17:05:34');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (16, 1, 10001, 0, 0, 6, '2023-09-17 17:06:10', 6, '2023-09-17 17:06:10');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (17, 1, 10001, 0, 0, 6, '2023-09-17 17:06:35', 6, '2023-09-17 17:06:35');
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`, `version`, `deleted`, `creator`, `create_time`, `updater`, `update_time`) VALUES (18, 1, 10002, 0, 0, 6, '2023-09-17 17:06:35', 6, '2023-09-17 17:06:35');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `access_token` varchar(255) DEFAULT NULL COMMENT 'accessToken',
  `access_token_expire` datetime DEFAULT NULL COMMENT 'accessToken 过期时间',
  `refresh_token` varchar(255) DEFAULT NULL COMMENT 'refreshToken',
  `refresh_token_expire` datetime DEFAULT NULL COMMENT 'refreshToken 过期时间',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` (`id`, `user_id`, `access_token`, `access_token_expire`, `refresh_token`, `refresh_token_expire`, `tenant_id`, `create_time`) VALUES (3, 6, 'eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiJiOTFlYjhhYmE3ZTU0YzVlODY0ZWE3NWJlYWJmZTc3NiIsInN1YiI6IjYiLCJpc3MiOiJGRiIsImlhdCI6MTY5NDk0MTcwMSwiZXhwIjoxNjk0OTQxNzYxfQ.0sDk-dTsD78vOnqMOTu1xj900qsxRZPHGr7PnPWwYuE', '2023-09-17 17:09:22', 'eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiIzZGQ2MTk0Y2Y1OTI0NzNkOGJlNDUyNDc2ZDdiYTliMiIsInN1YiI6IjYiLCJpc3MiOiJGRiIsImlhdCI6MTY5NDk0MTA2NiwiZXhwIjoxNjk1MDI3NDY2fQ.WdNCGaqx2HCTaQZjcFkaKPHXIakqvizeFmF-lXe5oPw', '2023-09-18 16:57:46', NULL, NULL);
INSERT INTO `sys_user_token` (`id`, `user_id`, `access_token`, `access_token_expire`, `refresh_token`, `refresh_token_expire`, `tenant_id`, `create_time`) VALUES (4, 10002, 'eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiJkOWRhMGVkNjY5OWM0MTQwYjcxYzA4NTJmZWFjYjlhNiIsInN1YiI6IjEwMDAyIiwiaXNzIjoiRkYiLCJpYXQiOjE2OTQ5NDExMzQsImV4cCI6MTY5NDk0MTE5NH0.x7EZNszMWGahRhUY55Bzm5Ndar9az_YnZ-D0zeBxF6o', '2023-09-17 16:59:54', 'eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiI4MWRkMjQ0NjExNDU0NjIyYmZmZjQ0OWEzNGUwNGM1NiIsInN1YiI6IjEwMDAyIiwiaXNzIjoiRkYiLCJpYXQiOjE2OTQ5NDExMzQsImV4cCI6MTY5NTAyNzUzNH0.plBiBunu2I0CY-yt0K9Su-3UVPYnMoM7AUbFEHfDUjg', '2023-09-18 16:58:54', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
